/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 80022
 Source Host           : localhost:3306
 Source Schema         : toolsDb

 Target Server Type    : MySQL
 Target Server Version : 80022
 File Encoding         : 65001

 Date: 19/12/2020 20:07:37
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tb_power
-- ----------------------------
DROP TABLE IF EXISTS `tb_power`;
CREATE TABLE `tb_power` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `type` int DEFAULT '0',
  `info` varchar(255) DEFAULT NULL,
  `toolid` int DEFAULT '0',
  `uid` int DEFAULT NULL,
  `createtime` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of tb_power
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for tb_tools
-- ----------------------------
DROP TABLE IF EXISTS `tb_tools`;
CREATE TABLE `tb_tools` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `createtime` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of tb_tools
-- ----------------------------
BEGIN;
INSERT INTO `tb_tools` VALUES (1, 'json解析', 'http://bpic.588ku.com/element_origin_min_pic/01/30/78/50573b238a0df9a.jpg', '进行json格式的小工具', 'https://www.sojson.com/simple_json.html', '2020-12-19 11:01:31');
INSERT INTO `tb_tools` VALUES (2, 'urlencode', 'https://ss1.bdstatic.com/70cFvXSh_Q1YnxGkpoWK1HF6hhy/it/u=1308913027,2378454174&fm=26&gp=0.jpg', '有 encodeURIComponent() 和 encodeURI() 函数', 'https://www.sojson.com/encodeurl.html', '2020-12-19 12:45:51');
INSERT INTO `tb_tools` VALUES (3, 'sdfsdfs', '', 'undefined', 'https://www.antdv.com/components/modal-cn/', NULL);
COMMIT;

-- ----------------------------
-- Table structure for tb_user
-- ----------------------------
DROP TABLE IF EXISTS `tb_user`;
CREATE TABLE `tb_user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(255) DEFAULT NULL,
  `nickname` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `avatar` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `powerType` int DEFAULT '0',
  `isManager` int DEFAULT '0',
  `registrationTime` datetime DEFAULT NULL,
  `lastLoginTime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of tb_user
-- ----------------------------
BEGIN;
INSERT INTO `tb_user` VALUES (1, '1933851647@qq.com', '大菠菜', '25f9e794323b453885f5181f1b624d0b', 'https://pic1.zhimg.com/80/v2-7d709be84be28d08b21928537ab079d1_720w.jpg', '一棵超瘦的大波菜', 0, 1, '2020-12-19 03:42:37', '2020-12-19 03:42:53');
INSERT INTO `tb_user` VALUES (5, '12334@qq.com', NULL, 'c8837b23ff8aaa8a2dde915473ce0991', NULL, NULL, 0, 0, NULL, NULL);
INSERT INTO `tb_user` VALUES (6, 'cccc@qq.com', NULL, 'e10adc3949ba59abbe56e057f20f883e', NULL, NULL, 0, 0, NULL, NULL);
INSERT INTO `tb_user` VALUES (7, 'zhangningbo@chehang168.com', NULL, 'e10adc3949ba59abbe56e057f20f883e', NULL, NULL, 0, 1, NULL, NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
